You are here: 1. Distribution System > 1.10. MAINTENANCE Menu: System Maintenance > 1.10.14. Maintenance - Other Maintenance > 1.10.14.3. Maintenance - Other Maintenance - Change Debtors > Changing a Batch of Debtor Numbers
Changing a Batch of Debtor Numbers

Debtor numbers can be changed in a batch from a prepared file that contains the old debtor number and the new debtor number in a standard ASCII comma delimited form (a CSV file). This file would normally be created using a text editor or spreadsheet such as Excel. The expected format for the CSV file is as follows:

Old Debtor Number, New Debtor Number

To import the debtor numbers to be changed from a CSV file:

  1. Select MAINTENANCE | OTHER MAINTENANCE | CHANGE DEBTORS.

Micronet displays the Change Debtor Numbers screen.

  1. Select EDIT | FILE.

Micronet disables the individual debtor fields.

  1. Complete the following fields:

 

Field

Value

 

Save Old Debtor

Select whether you want to save the old debtor number in the Debtor master file. Options are:

  • No - move the old debtor to the new debtor number (deleting the old debtor)
  • Yes - create a duplicate of the old debtor with the new debtor number (saving the old debtor)
  • Merge Debtors - consolidate the two debtors (quantities only). If the new debtor already exists, this option is chosen automatically.

 

Change History

Select whether you want the debtor number updated in the sales and account histories. Options are:

  • No - retain the sales and account histories with reference to the old debtor number
  • Yes - update your history files with the new debtor number. This effectively removes any trace of the old debtor number.
  1. Select FILE | START.

Micronet displays the standard Windows Open screen.

  1. Find and select the CSV file containing your changes to debtor numbers and select Open.

Micronet processes the requested debtor change, creating an output file of the same name as your CSV file but with a .err extension. This output file contains all errors along with the process date and time stamp.

 

Warning

Once started, do not try to stop the process under any circumstances.